A spreadsheet I have used for the past two years to keep track of progress in CTEC Business. The spreadsheet uses a VLOOKUP for marks given for each unit and it will automatically generate a mark for an LO. Really useful to display on the board for pupils to allow them to keep track of their own progress. Grades for each unit should be U, P, M or D.